How to: Add a value title to a chart.
Solution:
Select the chart, select the 'Insert' menu and select 'Titles...'. Select 'Value (Y) Axis' and type the desired title for the Y-axis.
To add a value title:
1) Select the chart to add a value (Y-axis) title:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separatechart sheet, click the tab for the chart sheet and double-click on the chart. (A striped border with handles appears around the chart.)
2) Select the 'Insert' menu select 'Titles...'. (The Titles dialog box appears.)
Titles dialog box
3) Select the 'Value (Y) Axis' check box of the 'Attach Text to' group.
4) Click 'OK'. (A text box with the character Y appears on the chart.)
5) Type the desired title for the Y-axis.
6) Press ENTER. (The desired title replaces the character Y.)
7) (Optional) Resize the chart and/or adjust the size and the location of the box.
